Notifications
Clear all

Cash - in and out *JAY - DON"T READ UNLESS YOU'RE VERY DRUNK

57 Posts
3 Users
0 Reactions
808 Views
Chomley-Warner
(@admin-infinity)
Posts: 15632
Illustrious Member Admin
Topic starter
 

Heh, forget my accounts - it's just yours you need to consider at the moment i.e. the Bryan balance sheet. Actual monies in and monies out.

 
Posted : 16/05/2008 12:38 pm
HeadShot
(@headshot)
Posts: 9991
Illustrious Member
 

I can't forget yours because I can't pay all the outgoings without that!

Here's the spreadsheet again without your money and without Guy's expenses which will have to come out of the monies you hold.-- attachment is not available --



 
Posted : 16/05/2008 12:57 pm
Chomley-Warner
(@admin-infinity)
Posts: 15632
Illustrious Member Admin
Topic starter
 

Stephen - a P&L sheet can show a loss (negative value), it's nothing to do with how payment is made, merely a record of incomings and outgoings. It can't be a partial record, it has to be complete else it has no value.

All we need is actual income and actual expenses for Bryan. I have dealt with the previous game's P&L - my balance will c/f along with yours in a separate sheet that will ultimately balance with the bank account (once I have been given deatils of where it has to go.

Again, P&L has nothing to do with where money is coming from or goes to.

 
Posted : 16/05/2008 1:23 pm
Old Un
(@old-un)
Posts: 6781
Illustrious Member
 

The balance of profit or loss from Eagles should be shown in the spreadsheet for this game ...esp as we carried over debts from Eagles paid for by bryan .
just ma thoughts!

 
Posted : 16/05/2008 1:38 pm
Chomley-Warner
(@admin-infinity)
Posts: 15632
Illustrious Member Admin
Topic starter
 

No, that's why Stephen's getting confuddled.
P&L shows where money goes, balance sheet shows where money is. Keep it separate, keep it simple, then everything always reconciles.

For accounting purposes P&L for Eagle is done, no need for any reference to that.

Need P&L for Bryan (actual income, actual expenditure).

Balance from Wotan + balance for Eagle + balance from Bryan = current cash assets = cash in paypal/CiA bank/CW bank
Balances can be positive or negative but the sum will always = cash in accounts

 
Posted : 16/05/2008 1:50 pm
HeadShot
(@headshot)
Posts: 9991
Illustrious Member
 

FFS.

The second spreadsheet I have attached shows the actual income and outgoings from Bryan.

If you don't want to include anything from TEHL in the Bryan game, then we shouldn't offer to cover costs for players attending in lieu of payment for props from TEHL, that's where the crossover lies and that's why I'm unable to pay Guy for his expenses from that account. I don't have the money to pay him. If the issue of payment for Che, Carl and Helga had not bee raised everything would be separate and I would be able to pay Guy and I would have a profit to carry forward.

£104.18 to be precise.....less the impending payment to TLSFX.

Are you suggesting that I shouldn't include Che, Carl and Helga's green fees in the Bryan spreadsheet? It's income to the Bryan budget, so why not?

I've separated out the accounts that I've exclusively dealt with for Bryan in that second spreadsheet. The first one I attached includes the carry-forward from TEHL to show exactly where we stand across the board.

Are we clear now?

I suggest in future we pay people in cash for services rendered at the point of receipt rather than carrying forward into the next game, then there's no crossover and you can keep each game separate with balance brought forward from the previous game(s).

S



 
Posted : 16/05/2008 2:32 pm
Chomley-Warner
(@admin-infinity)
Posts: 15632
Illustrious Member Admin
Topic starter
 

No, I'm not interested whether you can pay someone or not (money is somewhere within our grasp) - what I am interested in is a properly prepared set of accounts.
At the end of our first year (possibly before that) we will be asked to present accounts for bank audit or HMRC tax assessment and they won't be interested whether Stephen can pay someone or not!

Accounts have a purpose beyond a 'how much have I got in the bank'.

 
Posted : 16/05/2008 2:41 pm
HeadShot
(@headshot)
Posts: 9991
Illustrious Member
 

I just don't know what you are finding confusing about this Dave. I have a set of account in Excel that shows exactly where I stand for Bryan. I HAVE to include the £120 that we used from TEHL as part of my P&L sheet for Bryan because that's part of the income, but it's yet to be paid to me by you.

If this still isn't clear, someone else better do this because I did state when I was nominated that I had no experience of this and I'm trying as hard as I can to make it clear.

S



 
Posted : 16/05/2008 2:49 pm
Chomley-Warner
(@admin-infinity)
Posts: 15632
Illustrious Member Admin
Topic starter
 

Heh, I'm getting heavy. Sorry Stephen, don't mean to sound harsh - I realise you haven't haven't done accounts before (I've been doing it for 30 years!) - let's take it a step at a time.

 
Posted : 16/05/2008 2:50 pm
Old Un
(@old-un)
Posts: 6781
Illustrious Member
 

he he he ! Good job we're not for profit , we'd be all killing each other by now.

Anyhow it looks like we're still in the black so thats a good sign ! 8)

 
Posted : 16/05/2008 2:53 pm
Chomley-Warner
(@admin-infinity)
Posts: 15632
Illustrious Member Admin
Topic starter
 

1. P&L shows expenses and income
2. Balance sheet shows assets (bank accounts, cash floats, big props)

1. P&L can show a positive or negative amount
2. A balance sheet will. as the name implies, always balance - if it doesn't there is something wrong.

1. P&L shows how much cash you made or lost
2. Balance sheet show what assets you own and what assets you owe (i.e if you borrow £1000 is appears as a debt but is balanced by £1000 transferred to your bank account)

Accounts can show any 'period' but as our 'business' is periodic games it makes sense to do it per game. When the calendar year is up it might include three, four or five periods depending on how many games we squeezed in.

 
Posted : 16/05/2008 2:59 pm
Chomley-Warner
(@admin-infinity)
Posts: 15632
Illustrious Member Admin
Topic starter
 

So, from this you see that you can't include a balance from the Eagle game as income in the Bryan P&L accounts - they are separate
But in the Balance sheet there will be an entries for (at the moment):
CW's bank account
CiA's bank account
CiA's paypal account
CiA's cash account

 
Posted : 16/05/2008 3:03 pm
HeadShot
(@headshot)
Posts: 9991
Illustrious Member
 

he he he ! Good job we're not for profit , we'd be all killing each other by now.

Anyhow it looks like we're still in the black so thats a good sign ! 8)

Yes we are, very much so.

:kiss: :ghey:

OK. Right.

I have a spreadsheet that is for the Bryan game. It only shows income and outgoings for the Bryan game because that's all I've dealt with thus far.

I was asked how much money we have, I answered that question, several times, and included sub-totals on the money I have left over from Bryan as it stands today (£44.18). I then gave the subtotal including the £120 for Che, Carl and Helga's places and less the expenses I've yet to settle (£104.18) and the total balance of the monies we have left over with the balance brought forward (£316.58).

All of this is also subject to a deduction depending on the cost of TLSFX's invoice.

I'm going home for tea and biscuits now. :spam:



 
Posted : 16/05/2008 3:10 pm
Old Un
(@old-un)
Posts: 6781
Illustrious Member
 

He didn't like the way I did the membership either :roll: :rofl:

......member number 1 indeed...grumble grumble... :ghey:

Good job Jays safe ........


(done fuck all recently)

 
Posted : 16/05/2008 4:40 pm
Chomley-Warner
(@admin-infinity)
Posts: 15632
Illustrious Member Admin
Topic starter
 

Heh, I'm very serious! Proper accounts must be kept and presented to the bank and tax authorities. They don't give a toss how much money was made either before or after Bryan or indeed whether there was a profit or loss - the do require that accounts are presented in a standard form and that there is clarity and full information. (Not figures changing throughout the day :lol: ).

The only way to do this is by doing it correctly from the start, 'cos it will be a nightmare come year end to unravel (and unnecessary stress). We will be checked - claiming 'non-profit' status doesn't mean 'not-taxed'. Investigations are very bad news - HMCR's remit is very wide these days and they won't hesitate to widen the net to cover personal accounts of named individuals.

Stephen, tell me if I have made the concepts in my previous two posts clear and then we can progress to the next stage. I'm not criticising, I'm trying to help. The role of treasurer doesn't mean 'the person who signs cheques' it's the single most important position in the running of CiA, the interface between us and them!

Signed,
Membership No 1 (even though I handed the card to Guy and he refused it :rofl: )

 
Posted : 16/05/2008 6:48 pm
Chomley-Warner
(@admin-infinity)
Posts: 15632
Illustrious Member Admin
Topic starter
 

Im preparing a set of accounts for you so that you can see what goes where - we can use it as a template from now on....

 
Posted : 16/05/2008 8:04 pm
Old Un
(@old-un)
Posts: 6781
Illustrious Member
 

Yithness .......total Yithness.....

 
Posted : 16/05/2008 8:45 pm
Chomley-Warner
(@admin-infinity)
Posts: 15632
Illustrious Member Admin
Topic starter
 

LOL, and here's a man who is going to regret starting a limited company!

Formalising CiA comes with responsibilities, it's serious now!
Anyhoo, I'm doing it for Stephen for this time, it will be easy for the next game...

 
Posted : 16/05/2008 9:15 pm
Chomley-Warner
(@admin-infinity)
Posts: 15632
Illustrious Member Admin
Topic starter
 

Stephen - I just need one figure - the balance that's sitting in the paypal account please.

 
Posted : 16/05/2008 9:52 pm
HeadShot
(@headshot)
Posts: 9991
Illustrious Member
 

£854.18



 
Posted : 17/05/2008 5:31 am
Page 2 / 3
Share: